JBoss.org
Community Documentation
Next
Teiid - Scalable Information Integration
Teiid Reference Documentation
7.3
Copyright © 2009 Red Hat, Inc.
Legal Notice
Preface
1. SQL Support
1.1. Identifiers
1.2. Expressions
1.2.1. Column Identifiers
1.2.2. Literals
1.2.3. Aggregate Functions
1.2.4. Case and searched case
1.2.5. Scalar subqueries
1.2.6. Parameter references
1.3. Criteria
1.4. SQL Commands
1.4.1. SELECT Command
1.4.2. INSERT Command
1.4.3. UPDATE Command
1.4.4. DELETE Command
1.4.5. EXECUTE Command
1.4.6. Procedural Relational Command
1.5. Temp Tables
1.6. SQL Clauses
1.6.1. WITH Clause
1.6.2. SELECT Clause
1.6.3. FROM Clause
1.6.4. WHERE Clause
1.6.5. GROUP BY Clause
1.6.6. HAVING Clause
1.6.7. ORDER BY Clause
1.6.8. LIMIT Clause
1.6.9. INTO Clause
1.6.10. OPTION Clause
1.7. Set Operations
1.8. Subqueries
1.8.1. Inline views
1.8.2. Subqueries in the WHERE and HAVING clauses
2. XML SELECT Command
2.1. Overview
2.2. Query Structure
2.2.1. FROM Clause
2.2.2. SELECT Clause
2.2.3. WHERE Clause
2.2.4. ORDER BY Clause
2.3. Document Generation
2.3.1. Document Validation
3. Datatypes
3.1. Supported Types
3.2. Type Conversions
3.3. Special Conversion Cases
3.3.1. Conversion of String Literals
3.3.2. Converting to Boolean
3.3.3. Date/Time/Timestamp Type Conversions
3.4. Escaped Literal Syntax
4. Scalar Functions
4.1. Numeric Functions
4.1.1. Parsing Numeric Datatypes from Strings
4.1.2. Formatting Numeric Datatypes as Strings
4.2. String Functions
4.3. Date/Time Functions
4.3.1. Parsing Date Datatypes from Strings
4.3.2. Specifying Time Zones
4.4. Type Conversion Functions
4.5. Choice Functions
4.6. Decode Functions
4.7. Lookup Function
4.8. System Functions
4.9. XML Functions
4.9.1. JSONTOXML
4.9.2. XMLCOMMENT
4.9.3. XMLCONCAT
4.9.4. XMLELEMENT
4.9.5. XMLFOREST
4.9.6. XMLPARSE
4.9.7. XMLPI
4.9.8. XMLQUERY
4.9.9. XMLSERIALIZE
4.9.10. XSLTRANSFORM
4.9.11. XPATHVALUE
4.10. Security Functions
4.10.1. HASROLE
4.11. Nondeterministic Function Handling
5. Updatable Views
5.1. Key-preserved Table
6. Procedures
6.1. Procedure Language
6.1.1. Command Statement
6.1.2. Dynamic SQL Command
6.1.3. Declaration Statement
6.1.4. Assignment Statement
6.1.5. If Statement
6.1.6. Loop Statement
6.1.7. While Statement
6.1.8. Continue Statement
6.1.9. Break Statement
6.1.10. Error Statement
6.2. Virtual Procedures
6.2.1. Virtual Procedure Definition
6.2.2. Procedure Input Parameters
6.2.3. Example Virtual Procedures
6.2.4. Executing Virtual Procedures
6.2.5. Limitations
6.3. Update Procedures
6.3.1. Update Procedure Processing
6.3.2. For Each Row
6.3.3. Create Procedure
7. Transaction Support
7.1. AutoCommitTxn Execution Property
7.2. Updating Model Count
7.3. JDBC and Transactions
7.3.1. JDBC API Functionality
7.3.2. J2EE Usage Models
7.4. Transactional Behavior with JBoss Data Source Types
7.5. Limitations and Workarounds
8. Data Roles
8.1. Permissions
8.2. Role Mapping
8.3. XML Definition
8.4. System Functions
9. System Schema
9.1. System Tables
9.1.1. VDB, Schema, and Properties
9.1.2. Table Metadata
9.1.3. Procedure Metadata
9.1.4. Datatype Metadata
9.2. System Procedures
10. Translators
10.1. Introduction to the Teiid Connector Architecture
10.2. Translators
10.2.1. File Translator
10.2.2. JDBC Translator
10.2.3. LDAP Translator
10.2.4. Loopback Translator
10.2.5. Salesforce Translator
10.2.6. Web Services Translator
10.2.7. Delegating Translators
10.3. Dynamic VDBs
10.3.1. VDB Element
10.3.2. Model Element
10.3.3. Translator Element
10.4. Multi-Source Models and VDB
11. Federated Planning
11.1. Overview
11.2. Federated Optimizations
11.2.1. Access Patterns
11.2.2. Pushdown
11.2.3. Dependent Joins
11.2.4. Copy Criteria
11.2.5. Projection Minimization
11.2.6. Partial Aggregate Pushdown
11.2.7. Optional Join
11.2.8. Partitioned Union
11.2.9. Standard Relational Techniques
11.3. Federated Failure Modes
11.3.1. Partial Results
11.4. Query Plans
11.4.1. Getting a Query Plan
11.4.2. Analyzing a Query Plan
11.4.3. Relational Plans
11.5. Query Planner
11.5.1. Relational Planner
11.5.2. Procedure Planner
11.5.3. XML Planner
12. Architecture
12.1. Terminology
12.2. Data Management
12.2.1. Cursoring and Batching
12.2.2. Buffer Management
12.2.3. Cleanup
12.3. Query Termination
12.3.1. Canceling Queries
12.3.2. Timeouts
12.4. Processing
12.4.1. Join Algorithms
12.4.2. Sort Based Algorithms
A. BNF for SQL Grammar
A.1. TOKENS
A.2. NON-TERMINALS
Next
Preface